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 / gourab

if you have the same file structure.you can configure
indirect loading in the file properties tab of the
session.You will need only one source qualifier
transformation.

Please correct me if i am wrong..

Regards
Gourab

Is This Answer Correct ?    29 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

5244


What you know about transaction control transformation?

556


What are the tuning techniques you applied during your last project

1561


Parameter and variable differences

1613


Performance tuning( what you did in performance tuning)

1485






What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1180


What are the uses of etl tools?

647


suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

1733


Explain lookup transformation source types in informatica

696


How we can create indexes after completing the load process?

613


State the differences between sql override and lookup override?

621


How do you set a varible in incremental aggregation

1442


What are connected or unconnected transformations?

628


What are mapplets?

816


What do you understand by term role-playing dimension?

572