Answer / prabhu

As an informatica developer you will not mostly work in
Data modelling.It would be handled by seperate team like
DBA team

Prabhu
www.iskilltech.com

Answer / abhinaw prakash

I guess sometimes if you have been assigned a role of an
Developer/Solution Architect you should have a knowledge on
Data Modelling(Atleast one of its tools like Toad Data
Modeller etc).

i have one senario i have table with 2columns one for primary key another is a constant value(zero). i have to lookup the table and get the maximum primary key here i don't have any common column between source and lookup table(wt table i explained above)... table is (i am assuming he didn't give the table) column1 column2 5 0 2 0 8 0 6 0 3 0 12 0 7 0

2 Answers   TCS,

---

sample mappings for scd1,scd2 and scd3

2 Answers   Cognizant,

---

What is partioning?how many types of partinings are there

2 Answers   HCL,

---

Why use shortcuts(Instead of making copies).

1 Answers  

---

which transformation uses cache?

3 Answers   Keane India Ltd,

---

without using emailtask how will send a mail from informatica?

3 Answers  

---

In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?

1 Answers   iNautix,

---

I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.

4 Answers   Cap Gemini, IBM,

---

Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??

3 Answers   IBM,

---

How IN function works in informatica? Is it similar that of oracle IN function or different? Explain

2 Answers   Mphasis,

---

Separate from an archive server and a powerhouse?

0 Answers  

---

how do the project develops? pls specify right from the start to end in step by steps.

0 Answers   ITC Infotech,

---