How can we delete duplicate rows from flat files?
what is the diff b/w cached and unchaed look ups
What do you understand by term role-playing dimension?
What is IQD file?
write a query row to column follwing source? quarter sales q1 5000 q1 9000 q1 7000 q1 6000 q2 5000 q2 4000 q2 3000 q2 1000 q3 4000 q3 3000 q3 1000 q3 2000 q4 5000 q4 400 i want the output? q1 q2 q3 q4 sales
3 Answers Cognizant, Flextronics,
What do you mean by blocking transformation?
What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?
what is parallel querying and what r hints.
How do you implement unconn. Stored proc. In a mapping?
What are the differences between a connected lookup and unconnected lookup?
There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How can you load all files into targets?
What are the advantages of using informatica as an etl tool over teradata?
difference between stop and abort