Answer / sunil

)At DB level we can simply DROP the stagin table.
2)then Create Target table at DB level.
3) Directly LOAD the records into target table.

NOTE: It is recommended to use staging area

In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.

2 Answers   TCS,

---

Update strategy transformation is an active transformation.How it changes the number of records that pass through it? Please explain....

2 Answers  

---

Suppose we have a (assume relational) source table Product_Id Month Sales 1 Jan x 1 Feb x . . . . . . 1 Dec x 2 Jan x 2 Feb x . . . . . . 2 Dec x 3 Jan x 3 Feb x . . . . . . 3 Dec x . . . . . . and so on. Assume that there could be any number of product keys and for each product key the sales figures (denoted by 'x' are stored for each of the 12 months from Jan to Dec). So we want the result in the target table in the following form. Product_id Jan Feb March.. Dec 1 x x x x 2 x x x x 3 x x x x . . So how will you design the ETL mapping for this case , explain in temrs of transformations.

5 Answers   Accenture, VAMA,

---

difference between source based commit? and target based commit? which is better with respect to performance?

6 Answers   IBM,

---

How to create a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 O/P - shud have only one id with the min(date) How to create a mapping for this

9 Answers   Deloitte,

---

---

if the session fails after 100 records agian we have to starts the session or we go for recovery session

2 Answers   TCS,

---

What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?

1 Answers  

---

which T/r we can use it mapping parmeter and mapping variable? and which one is reusable for any mapping mapping parmeter or mapping varibale?

3 Answers   Wipro,

---

While importing the relational source definition from the database, what are the metadata of source that will be imported?

0 Answers   Informatica,

---

i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task

14 Answers   Altisource, TCS,

---

How do you take care of security using a repository manager

2 Answers  

---

i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow

3 Answers   Wipro,

---