What are the different types of schemas?
Answers were Sorted based on User's Feedback
What is lookup change?
what is parallel querying and what r hints.
What is data merging,data cleansing,sampling?
What is informatica etl tool?
whether Sequence generater T/r uses Caches? then what type of Cache it is
I have the input file as col1 col2 col3 3 2 1 7 6 8 I should get the output as col1 col2 col3 1 2 3 6 7 8 ....What is the logic to get this? Is there any transformation which sorts row wise ? If not how to sort the incoming records row wise?
What is use of batch file in informatica? How many types of batch file in informatica?
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000
What is the use of source qualifier?
What are the challenges of Dataware housing in the future?
What is Micro Strategy? Why is it used for?
Source is a flat file and want to load unique and duplicate records separately into two separate targets; right??