We can't use sql override or other properties when using
Flat file as source. Then what is the use of Source
Qualifier transformation?

Answer Posted / sripal

While loading into Target, Integration Service start reading the source data from Source qualifier irrespective of Relational/Flat Sorce files.

I guess I hit your question.

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the restrictions of union transformation?

576


What is an active transformation?

645


Explain the different kinds of facts.

562


What is source qualifier transformation in informatica?

571


what is informatica metadata?

597






How do you use reject loader.

2071


How do we call shell scripts from informatica?

593


What is pmcmd command?

672


How can we handle two sessions in informatica?

610


Enlist few areas or real-time situations where informatica is required.

588


What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

7671


Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

1507


Different circumstance which drives informatica server to expel records?

549


What is intricate mapping?

588


What is substr in informatica?

659