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
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
Briefly explain the aggregator transformation?
Explain the code page compatibility?
What is session task and command task?
What is the use of code page?
Differentiate between Load Manager and DTM?
What all are steps in up gradation of Informatica server?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What is the function of aggregator transformation?
What is intricate mapping?
What is target designer and target load order?
In informatica workflow manager, how many repositories can be created?