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

So in this situation we used the source qualifier transformations to convert the external datatype to informatica native datatype and by default source qualifier transformations is created if our source is a flat or relational tables and also one property is tracing level

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to differentiate between the active and passive transformations?

623


Dimension Object created in Oracle can be imported in Designer Cubes contain measures

1934


What are the modules in Power Center

1234


In warehouses how many schemas are there?

583


Partition, what happens if the specified key range is shorter and longer

2029






What is meant by lookup transformation?

612


Why update strategy and union transformations are active?

592


What is substr in informatica?

661


Mention some types of transformation?

605


Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

1621


What is a passive transformation?

638


without table how to come first record only in oracle?

1851


Explain about Informatica server process that how it works relates to mapping variables?

622


How to extract the informatica rejected data?

753


What are some examples of informatica etl programs?

533