how to join two flat file if they have diff. structure?how to join one relational and one flat file?




Answers were Sorted based on User's Feedback



how to join two flat file if they have diff. structure?how to join one relational and one flat file?..

Answer / sravanthi

using joiner tranformation to add two diff structure of flat files...

Is This Answer Correct ?    7 Yes 2 No

how to join two flat file if they have diff. structure?how to join one relational and one flat file?..

Answer / pradosh

if the flat files has diff stracture then
sd-->sq-->exp>
...>join-->tgt
sd1-->sq1-->exp1>

that means take flat file source then take 2 exp transformation in which u take variabl ports i.e a=1 and exp1 is b=1 then based on condition u take a joined trans and connect to target.

join takes diferent sources

Is This Answer Correct ?    4 Yes 0 No

how to join two flat file if they have diff. structure?how to join one relational and one flat file?..

Answer / vijay

you have two flat-files with u.
prepare two source instances with the structure you have as
oracle relational tables. after that change them to
flatfiles in the source instances.
then connect to the target's that u already prepared by
simple-pass mapping. now you have two relational source
tables with u,then join the tables using joiner.
--------------------------------------------------
how to join one relational and one flat file?
same as above convert the flatfile to relational table
through simple-pass mapping. now join two relational tables
using joiner in the same mapping itself.

Is This Answer Correct ?    0 Yes 0 No




how to join two flat file if they have diff. structure?how to join one relational and one flat file?..

Answer / mehul thakur

Hi sravanti
Could U please explain how to join ?

Is This Answer Correct ?    0 Yes 1 No

Post New Answer



More Informatica Interview Questions

hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE USING SQL T/R ?

4 Answers  


How to load duplicate records in to a target table which has a primary key?

2 Answers  


i have oracle table A and target B. i don't know how many records. i want get get last record in table A as first record in target table B. write a sql query?

7 Answers   IBM, TCS,


i have one table like cust_id ph1 ph2 ph3 1002 9290123526 97671927210 9876545232 we use Normalizer wt is o/p? sue normalizer we can generate three tables in single table/

4 Answers  


Mapplets ( can you use source qyalifier, can you use sequence generator, can you use target)

1 Answers  






IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP TRANSFORMATION ?

4 Answers   HP,


i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .

6 Answers   Emphasis,


1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?

2 Answers   Accenture,


Is it possible to update the target table with PK?

1 Answers   TCS,


what is plsql table?

2 Answers  


Can anyone briefly describe abt audit table loading?

2 Answers   TCS,


wt is informatica file watch timers in aflat i want to get the first record and last record how could i.

1 Answers   CTS,






Categories