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).

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

0 Answers  

---

What are the mapings that we use for slowly changing dimension table?

2 Answers  

---

Why the UNION TRANSFERMATION is an Active TRANSFERMATION

6 Answers   Emphasis,

---

What is target load order?

0 Answers  

---

By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?

1 Answers  

---

write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000

1 Answers   HP,

---

I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution

5 Answers  

---

How many ways a relational source definition can be updated and what are they?

0 Answers   Informatica,

---

What is the Rank index port in Rank transformation?

0 Answers   Informatica,

---

Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static

2 Answers   Accenture,

---

how to load rows into fact table in data warehouse

0 Answers   Informatica,

---

hi all hi have flat file like below my requirement is empid,ename,sal,loc 101,vamshi,5000,hyd 101,vamshi,5020,hyd 201,raju,5000,hyd 202,ram,4000,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd i want the o/p like this in one target 201,raju,5000,hyd 202,ram,4000,hyd and in second target 101,vamshi,5000,hyd 101,vamshi,5020,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd

9 Answers   IBM,

---