Пікірлер
@mram1690
@mram1690 20 сағат бұрын
hi i did same process but i got the error "java [ERROR] java.lang.OutOfMemoryError: Java heap space " please guide me on this error
@mram1690
@mram1690 22 сағат бұрын
hi i follow same process which you explain that one i was run job it is successfully but it is emp table is loaded zero records others tables like dept & salgrade loaded successfully can you guide me please what is the problem.
@dineshkumarbaghar4932
@dineshkumarbaghar4932 3 күн бұрын
I got confused a lot watching this video 🙂
@nireeshag198
@nireeshag198 5 күн бұрын
Excellent explanation sir. Thankyou so much!
@hemanthkumarchinta667
@hemanthkumarchinta667 5 күн бұрын
Hi Sir, i'm attending to interviews as an ETL Developer. i was asked questions on complex mapping and transformations in iics. can u please provide me complex mapping and what are the issues we will face while developing it.
@Basha-f2t
@Basha-f2t 5 күн бұрын
Why did you use lookup persistent cache, As it will occupy the space not delete , is there any use, if it is corrupted, how to recover
@Basha-f2t
@Basha-f2t 6 күн бұрын
your video's not having high quality
@dllip87
@dllip87 8 күн бұрын
Can we use parameters/variable in synchronisation task? If yes, please make a video on that along with to update the parameter value for incremental load.
@dineshkumarbaghar4932
@dineshkumarbaghar4932 9 күн бұрын
Hello Sir, Could you please add theory at least definition before jump into the practical. it would be great if you add so people can understand why we are doing and what the use.
@acceleratoronly475
@acceleratoronly475 11 күн бұрын
Hello Roshan, I told the same way when I was asked this question in an Interview .. but Interviewer asked me 2 more approaches of doing the same which I am not sure.
@dineshkumarbaghar4932
@dineshkumarbaghar4932 12 күн бұрын
I tried without linking source to Sequence gen transformer and it worked for me and i disabled incoming fields.
@juliburnwal9940
@juliburnwal9940 15 күн бұрын
what if the question is to get the 3rd max salary value by using sorter and aggregator tf only? how to acheive that? i got asked this scenario in one interview?
@informationcounter1983
@informationcounter1983 22 күн бұрын
I would like to see if 2 files are arriving same time. in your example you feed 2 files but with time gap
@ETLSTATION
@ETLSTATION 18 күн бұрын
yes you can try that
@informationcounter1983
@informationcounter1983 18 күн бұрын
@@ETLSTATION IICS doesn't support, I guess
@ramjan135
@ramjan135 25 күн бұрын
Hi buddy, can you make one video, in which you can read data from SAP and apply filter on date column with time format possibilities? May be you can cover incremental load form SAP to any target? Thanks in advance.
@user-vd3ew4xn4w
@user-vd3ew4xn4w 26 күн бұрын
to_timestamp('$Lastruntime','YYYY-MM-DD HH24:MI:SS')-6/24 in oracle it is not working and it's showing >> ERROR: Prepare failed. : [ FnName: Execute -- [Informatica][ODBC Oracle Wire Protocol driver][Oracle]ORA-00907: missing right parenthesis ]
@nareshkumar-jl4ke
@nareshkumar-jl4ke 26 күн бұрын
good explanation watching from whitefiled bangalore working in one of the MNC companies
@juliburnwal9940
@juliburnwal9940 27 күн бұрын
How to implement scd-2 by using dynamic lookup?
@dineshkumarbaghar4932
@dineshkumarbaghar4932 Ай бұрын
Just trying to understand why in parameter file we define $$src_par why not $$src_param ?
@ETLSTATION
@ETLSTATION 29 күн бұрын
what happens when u define $$src_param
@user-ln3cg2fe4q
@user-ln3cg2fe4q Ай бұрын
Nice teacher❤
@yazhinisnest9320
@yazhinisnest9320 Ай бұрын
Thanks
@kamasanichittibabu5013
@kamasanichittibabu5013 Ай бұрын
How to generate the file in respective path for file listner?
@ETLSTATION
@ETLSTATION Ай бұрын
files can be created by source team or one of your job is creating then u can use pre or post session script . in unix it would be easy , windows u have to write windows bat file for same
@kamasanichittibabu5013
@kamasanichittibabu5013 Ай бұрын
do we have checkin and checkout in IICS?
@ETLSTATION
@ETLSTATION Ай бұрын
no
@kamasanichittibabu5013
@kamasanichittibabu5013 Ай бұрын
can u please make a video on key range partitioning and fixed partitioning
@kamasanichittibabu5013
@kamasanichittibabu5013 Ай бұрын
Please start CAI next
@kamasanichittibabu5013
@kamasanichittibabu5013 Ай бұрын
can u create a video on scd type 2( insert, update,reject,reprocessing)
@prakasharc7629
@prakasharc7629 Ай бұрын
Thank you for the video. In CDI, I want to copy part of the XML node and then write to new XML file. Is this possible in informatica data integration?
@kamasanichittibabu5013
@kamasanichittibabu5013 Ай бұрын
How to get both first and last row
@kamasanichittibabu5013
@kamasanichittibabu5013 Ай бұрын
One of the best channel to learn IICS.. Thankyou
@Usama_arm
@Usama_arm Ай бұрын
Hello, I am looking for a IICS developer who can help me in my job. If you know anybody, please reply and i will send my number. It is an urgent requirement. Please help.
@kamasanichittibabu5013
@kamasanichittibabu5013 Ай бұрын
screen is blur after 9mints
@yuvarajraghunapu7339
@yuvarajraghunapu7339 Ай бұрын
Bro. Can we create individual files each book?
@subhashini25b
@subhashini25b Ай бұрын
Hi Roshan while I ran the job I got the error cannot create an Unstructured Data transformation. Can I know the reason for this.
@VenkatReddy-zo3kx
@VenkatReddy-zo3kx Ай бұрын
Roshan thanks for the video, but is there any way to load incremental data without any audit columns(date columns) in source. if it is there kindly make a video on it. thanks in advance
@VenkatReddy-zo3kx
@VenkatReddy-zo3kx Ай бұрын
Roshan thanks for the video, but is there any way to load incremental data without any audit columns(date columns) in source. if it is there kindly make a video on it. thanks in advance
@joydeepchakraborty3391
@joydeepchakraborty3391 Ай бұрын
IICS me import powercenter task is not available... any idea why?
@user-dz6it8wr6e
@user-dz6it8wr6e Ай бұрын
Hi Sir ,hope you are doing good. Sir how to check workflow running on past 6 months
@ETLSTATION
@ETLSTATION Ай бұрын
you are asking for iics or powercenter , there is no worklfow in iics , we have taskflow in iics
@user-dz6it8wr6e
@user-dz6it8wr6e Ай бұрын
@@ETLSTATION Hi Sir I am asking powercenter sir
@ETLSTATION
@ETLSTATION Ай бұрын
@@user-dz6it8wr6e powercenter either you have go have audit table for each run where you can see this or need to have access to repository table where it will show you workflow run information
@akashrathod6659
@akashrathod6659 Ай бұрын
Hi Sir
@venkateshmangamolla
@venkateshmangamolla Ай бұрын
every day we are trying to load to target the code is not into production still it in testing phase 1st day the vendor sends 10 columns with the header and coma separeted and we load that file to target and next day the vendor sends 5 columns and 4 columns like this every day in the file but vendor is not changing any columns or add new columns and the vendor jumbling position of the columns and vendor is not pass null for missing columns this is the structure the file need to load data without losing any record how will you load the data to target in power center
@prashanthbaskaran
@prashanthbaskaran 2 ай бұрын
Hello Sir I'm using parameterization in my mapping and I had rank to remove duplicates using, but that ID column is not listed in the Group By tab.
@juliburnwal9940
@juliburnwal9940 2 ай бұрын
Hi, the way of explaining strategy is too good, just a question in my mind why we are not using data driven functionality like dd_update, dd_insert here in target table to insert & update the records or we can use? if yes then how?
@juliburnwal9940
@juliburnwal9940 2 ай бұрын
hi, while practicing by mistake instead by using one dummy field i used the sequence TF with the source direct & got the same values as required..so why the dummy field used not directly connected to the source TF as getting the same values? sorry in advance if its a silly question... just wanted to be clarify the topic more
@aragrot
@aragrot 2 ай бұрын
Hi master!! Greetings from Mexico. Do you work with microsoft fabric in Lakehouse?
@ETLSTATION
@ETLSTATION 2 ай бұрын
No buddy , i dont work in that tool
@juliburnwal9940
@juliburnwal9940 2 ай бұрын
can we use relational table as a target instead of a FF? it will work same?
@juliburnwal9940
@juliburnwal9940 2 ай бұрын
why sorter input as well as the sorter TF we have to use in joiner TF? why not only sorter input? or if only using one what its going to effect?
@Shv-ib9gq
@Shv-ib9gq 2 ай бұрын
Hi just a small query, after exporting the workflow from prod to non prod environment do I need again create the odbc src and tgt connections or I can just modify the parameter connections from the param file and it runs?
@RiteshGatpalli
@RiteshGatpalli 2 ай бұрын
Please open the content for all, good scenarios are locked behind member only content
@RiteshGatpalli
@RiteshGatpalli 2 ай бұрын
Your dynamic mapping task is locked under membership. Can you please make it available to all
@CamilleMantuano-sm1pq
@CamilleMantuano-sm1pq 2 ай бұрын
Its helpful but some information is not accurate and the video is blurred.
@ETLSTATION
@ETLSTATION 2 ай бұрын
please suggest which information is not correct so i can correct it
@mardinliserseri1
@mardinliserseri1 3 ай бұрын
Thanks for this informative and crucial tricks.