Interested to Buy Any Domain ? << Click Here >> for more details...
We can't use sql override or other properties when using
Flat file as source. Then what is the use of Source
Qualifier transformation?
- 3 Answers
- 12910 Views
- I also Faced
- E-Mail Answers
Answer Posted / mahesh
override option will work only on relational database for that
purpose we source qualifier will not use on flat files.
whenever u write a query in source qualifier it will goes
directly to that data base and execute the query n send the
result set to the informatica level. in flat files there is no
there is no database servers for flat files.
Hope u r understand now
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Can u generate reports in Informatica?
What is informatica?
How can we create index after completion of load process?
What is persistent lookup cache?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
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 .
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Explain joiner transformation in informatica
What are the types of caches in lookup? Explain them.
What is option by which we can run all the sessions in a batch simultaneously?
Explain how to import oracle sequence into informatica?
Explain the difference between a data warehouse and a data mart?
What is rank index in rank transformation?
How do you load first and last records into target table?
Target increases every day even though no new record was inserted
