How to load relational source into file target?
Answer Posted / rkumar.etl
use mapping designer create source db file as well as tgt
flat file with required column information .
While creating session provide the tgt file directory to get
the information.
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
During the running session, output files are created by informatica server. Enlist few of them.
What is Index Caches size?
what is degenerated dimension?
Why sorter is an active transformation?
What are junk dimensions?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Explain sql transformation in script mode examples in informatica
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
How will the document be delivered to me?
What is the scenario which compels informatica server to reject files?
Does an informatica transformation support only aggregate expressions?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
Explain your project of banking domian.
what are the different types of transformation available in informatica. And what are the mostly used ones among them?