Answer Posted / jaspreet banga

For This we Have to Use Job Control table(JCT), JCT is used
to select only those records which are provided next day
and then in mapping :---
1.) In source Qualifier write a pre sql query to read only
those record which are provided previous day, ]
2.)In router Route the data for update and insert.
3.) Use 2 update strategies i.e.., one for updating
existing record and other for inserting new one.
(Type-1 SCD) if you dont want to preserve the history.

Explain sessions. Explain how batches are used to combine executions?

1026

---

Which transformation should we use to normalise the COBOL and relational sources?

1200

---

Is it possible to revert a global repository to local one and why?

1078

---

Can we create a node as a gateway node and the same node can be assigned to a grid?

1077

---

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1976

---

What is rank transformation?

987

---

How are the sources and targets definitions imported in informatica designer?

1099

---

Define filter transformation?

1092

---

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

2069

---

How might you approve all mappings in the archive all the while?

1016

---

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1105

---

what are factless facts? And in which scenario will you use such kinds of fact tables.

1806

---

What are the modules in Power Center

1675

---

What are the differences between a connected lookup and unconnected lookup?

1068

---

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1951

---