Answer Posted / jvdwhinfo

Hi Guys,

First of all create a new flat file and paste the location
of all the flat files in that newly created flat file.
Now import the source definition using "Import from file"
and define the mapping.
And assign the session properties as indirect file type of
loading and give the location of the newly created file.

This should do and please let me know if you want me to
discuss further.

Thanks,
James

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

2171

---

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

2072

---

Explain the different lookup methods used in informatica?

1098

---

Define the various join types of joiner transformation?

1041

---

what is the size of u r source(like file or table)?

2310

---

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2191

---

Explain what is informatica metadata and where is it stored?

1108

---

what is informatica metadata?

1090

---

What are pre and post-session shell commands?

1389

---

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9900

---

What are the types of data warehouses?

1576

---

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1918

---

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

2109

---

What is the surrogate key?

1365

---

can we override a native sql query within informatica? Where do we do it?

1166

---