Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000. but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer

0 Answers  

---

Partition, what happens if the specified key range is shorter and longer

0 Answers   Cap Gemini,

---

in which situations do u go for starflake schema ?

6 Answers   TCS,

---

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b,the target shd be loaded as 1 a+b+c or 1 a||b||c, what transformations shd be used for this?

3 Answers   CTS, Wipro,

---

How can we trouble shoot the commas in a column of a comma delimited flat file in Informatica

1 Answers  

---

what is mean by complex business rule ?

0 Answers   Cap Gemini,

---

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

0 Answers   Saama Tech,

---

How to generate sequence numbers without using the sequence generator transformation?

0 Answers   Informatica,

---

Hi, Can anyone just give me the list of all versions of Informatica ? Advance Thanks

2 Answers   IBM,

---

Which transformation should u need while using the cobol sources as source defintions?

2 Answers  

---

i have two tables,table 1 having 2 columns and 3 rows,table2 having 3 columns and 2 rows.what is the output if i do left outerjoin,full outer join,right outer join?

2 Answers   IBM, Polaris,

---

waht is dataware house

2 Answers  

---