Answer / rao

THE BEST EXAMPLE IS SCD-1

Answer / abhinaw prakash

when you use dynamic lookup t/r a new row will be added to the lookup(lookup row port).
Use a router for insert and update.
have 2 update strategy t/r and give the xpression lookuprow port as 1(insert) and 2(update).
connect it to the target.

every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.

1 Answers   IBM,

---

I have a text file name x With a text message. Word informatica Is repeated for n number of times. How to count the number of occurrence Of word informatica Of word informatic in this file x.

1 Answers   Wipro,

---

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

0 Answers   IBM,

---

How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...

3 Answers   Cap Gemini,

---

My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1 from dual? what is the out put of the above queries?

3 Answers   HP,

---

What are the guidelines to be followed while using union transformation?

0 Answers   Informatica,

---

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

0 Answers  

---

What is the benefit of partitioning a session?

0 Answers  

---

What do you mean by enterprise data warehousing?

0 Answers  

---

1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach

4 Answers   Virtusa,

---

Can you use the maping parameters or variables created in one maping into any other reusable transformation?

1 Answers  

---

What does reusable transformation mean?

0 Answers  

---