How to load relational source into file target?

Answers were Sorted based on User's Feedback



How to load relational source into file target?..

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

How to load relational source into file target?..

Answer / jang

It should be a direct 1-1 mapping, source having relational
table and Target a Flat file

Is This Answer Correct ?    4 Yes 0 No

How to load relational source into file target?..

Answer / kammari.krishnaiah

load the data form source system to target in two ways.
one is directly storing another one is mapping (etl)in
infirmatia

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Informatica Interview Questions

why we use informatica in our project?

2 Answers   TCS,


what are the Methods For Creating Reusable Transformations?

0 Answers   Informatica,


in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?

9 Answers   Target,


In a concurrent batch if a session fails, can you start again from that session

1 Answers  


CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks

4 Answers   CSC,


Explain your project of banking domian.

0 Answers   Cap Gemini,


what is update strategy transformation ?

7 Answers   TCS,


What is the filename which you need to configure in UNIX while installing infromatica?

2 Answers   Accenture,


What is meant by active and passive transformation?

0 Answers  


what is parallel querying and what r hints.

1 Answers  


What is partioning?how many types of partinings are there

2 Answers   HCL,


in oracle write query yourname+1 from dual

5 Answers  


Categories