Which means the first record should come as last record and last record should come as first record and load into the target file?
No Answer is Posted For this Question
Be the First to Post Answer
State the limitations where we cannot use joiner in the mapping pipeline?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
write s sql query following table some duplicate present i want unique one column duplicate another column display? name id a 1 a 1 b 2 b 2 c 3 i want the required output like unique duplicate name id name id a 1 a 1 b 2 b 2 c 3
what r the transformations that r not involved in mapplet?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.
How to use pmcmd utility command?
How to create the source and target database connections in server manager?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
How do you load unique records into one target table and duplicate records into a different target table?
I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,