i have two flat files.. containing same type of data
i want to load it to dwh..how many source qualifires i need
Answer Posted / naveen
If u have same structure then u can use union transformation
Is This Answer Correct ? | 2 Yes | 8 No |
Post New Answer View All Answers
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What is source qualifier transformation in informatica?
What is confirmed fact in dataware housing?
What is a joiner transformation and why it is an active one?
Do you find any difficulty while working with flat files as source and target?
What do you understand by SOA of Informatica?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What the difference is between a database, a data warehouse and a data mart?
What are the informatica performance improvement tips
What is the sequence generator transformation in informatica?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Explain sql transformation in script mode examples in informatica
How to generate sequence numbers using expression transformation?