Answer / sravanthi

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

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

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.

Answer / mehul thakur

Hi sravanti
Could U please explain how to join ?

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

0 Answers   TCS,

---

What are the different caches used in informatica?

3 Answers   UST,

---

Dovelopment work (mapings,workflows)and unit testing also done in informatica ,then wt we do ? pls give me detail?

1 Answers  

---

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

0 Answers  

---

 Suppose you have n no.of records @ your flat file and you have seen some of records are missing while reaching to the destination. How can you trouble shoot it?

2 Answers   DELL,

---

---

what is data driven?

1 Answers  

---

What is the difference between OLTP and ODS?

4 Answers  

---

what is parallel querying and what r hints.

1 Answers  

---

Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?

6 Answers   Accenture, HCL,

---

how to use incremental load?

2 Answers   TCS,

---

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,

---

how will you get 21 to 30 record from 50 records?

6 Answers  

---