State the differences between sql override and lookup override?
- 0 Answers
- 841 Views
- I also Faced
- E-Mail Answers
Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
How the informatica server increases the session performance through partitioning the source?
what is the hint? how to use it to reduce the query processing in program?
How to fix the etl bugs..Tell me the process?
There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping
What are two types of processes that informatica runs the session?
how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.
Describe data concatenation?
can every transfomation reusable?how?
What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?
Hi Friends, How i could convert a cobol file (VSAM) into the flat file? How i could edit a cobol source file (VSAM)? I want to introduce few columns in the source file and finally the target should be in the Cobol itself. Kindly suggest me friends. Thanks in Advance, Innai
Teradata 
