Answer / divi

Alternative to Lookup id Joiner.we need to import source
structure of target in Source Analyser and bring that into
mapping and use it for comparison like Lookup.

Answer / krishna

In the sesion u hav to put update else insert

Answer / shashiall

plz..use "update else insert" in the properties of session.

Answer / saritha

You can use Joiner transformation to design scd Type1
manually. Import target as source and use joiner
transformation. Use expression to insert and update the
rows into target.

Scenario is like this: Name Sal A 10; B 20; C 30; Then Output should be Name Sal A 10; B 20; C 30; Total 60; Use SQL For this scenario

4 Answers   TCS, Wipro,

---

What is the difference between writing a joiner query in ANSI style and THETA style?

0 Answers   TCS,

---

i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need

7 Answers   Deloitte,

---

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

0 Answers   Informatica,

---

How to call shell scripts from informatica?

0 Answers  

---

hw cn v elimate dublicate values from lookup without overriding sql?

7 Answers   CTS,

---

While migrating the data from one environment to another environment how would you manage the connections?

0 Answers  

---

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

0 Answers   iGate,

---

If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?

1 Answers   Amdocs,

---

What is polling in informatica ?

1 Answers   TCS,

---

All active transformations r passive or not?

7 Answers  

---

how do u tune queries?

1 Answers  

---