Answer Posted / pragya

Can you please send this to me as well at my id
cool.pragya11@rediffmail.com

Thanks in Advance..

How many steps etl contains?

993

---

can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge

1867

---

How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?

2315

---

What is a materialized view log?

1046

---

what are the reports developed in sap bw project and what is the requirement for developing it?

2229

---

how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)

2742

---

How many types of transformations supported by sorted input?

1286

---

Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks

1840

---

Explain what are the various etl tools in the market?

991

---

What is virtual Data Warehousing?

1034

---

how to connect to a flatfile through ftp in informatica

14387

---

how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

2089

---

When do we analyze the tables? How do we do it?

1003

---

explain the methodology of Data Warehousing?(Polaries)

2080

---

Can anyone explain me a scenario from banking and finance...more precisely a mapping

2551

---