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


Please Help Members By Posting Answers For Below Questions

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

1876


What is source qualifier transformation in informatica?

578


What is confirmed fact in dataware housing?

5693


What is a joiner transformation and why it is an active one?

580


Do you find any difficulty while working with flat files as source and target?

680






What do you understand by SOA of Informatica?

592


What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

720


How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1338


How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

716


What the difference is between a database, a data warehouse and a data mart?

599


What are the informatica performance improvement tips

617


What is the sequence generator transformation in informatica?

616


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.

789


Explain sql transformation in script mode examples in informatica

607


How to generate sequence numbers using expression transformation?

647