Answer Posted / rt

HLD is the main block of the program
LLD is the sub blocks from the main block of the program

Define enterprise data warehousing?

1208

---

What are batches?

1103

---

What if the source is a flat-file?

1115

---

What is workflow? What are the components of the workflow manager?

1146

---

explan ur project architecture?

2073

---

What is meant by lookup transformation?

1111

---

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

2039

---

can we override a native sql query within informatica? How do we do it?

1130

---

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

1084

---

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2134

---

Explain transaction control transformation in informatica

1272

---

If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1497

---

Explain the different dimensions.

971

---

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.

2201

---

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7396

---