Answer Posted / eswar

It's not possible to find count of source table records through target table if both databases are different.

Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?

3821

---

Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.

2262

---

explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com

4172

---

How to delete data which is not in source table?

1390

---

How many steps etl contains?

992

---

dimension object created in oracle can be imported in designer?how?

3052

---

What is grain of fact?

1024

---

What is cube grouping?

1154

---

What is Data Vault???

2786

---

What are the types of data warehouse applications and what is the difference between data mining and data warehousing?

1056

---

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

2135

---

when will use SQL override in a lookup transformation?

2341

---

Explain do we need an etl tool?

1074

---

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

1865

---

What are various etl tools in the market?

1079

---