Answer / subhrangshu

Sequence generator may create issue in case of partitioning. The duplicate keys get generated in sequence generator. We cannot have cannot have multiple table feeder processes.
Then, we can use either Oracle database sequences or Lookup / Expression transformation to create sequence numbers. Although, Oracle sequences are better as it
will also handle the case where there are other sources feeding the Target under consideration other than ETL. Yes, there is slight hit in performance, but it's minor in most situations.

draw informatica architecture 8.6 ?

0 Answers   Cognizant, TCS,

---

what is incremental loading ?

12 Answers   CTS, IBM, Oracle, TCS,

---

What is workflow monitor?

0 Answers  

---

My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?

3 Answers   Span Systems,

---

HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in the expression transformation and the aggregator transformation. But, what exactly I want is .. If we have million of records,it is not possible using decode and search for that Particular Id to pivot into Horizontal data... Can any one of guys please help me in this regard.....

3 Answers   TCS,

---

What are batches?

0 Answers  

---

We can't use sql override or other properties when using Flat file as source. Then what is the use of Source Qualifier transformation?

3 Answers  

---

i did MBA in 2008. i got job as a Software Engineer(Informatica) in 2008 February in our college campus interviews through consultancy. my problem is when iam going interview HR people ask " YOu are MBA graduate how u get software(informatica) job". iam saying i got job in campus interviews. i have knowledge in informatica in dataware housing. is this answer correct or not. plese give me guidence

1 Answers   IBM,

---

What are the mapping parameters and mapping variables?

0 Answers   Informatica,

---

What is the exact difference b/w IN and EXIST in Oracle..?

4 Answers   Wipro,

---

can we use lookup t/r in flat files?what are the t/r's can be used in flat files when compared to relational DB?

2 Answers   IBM,

---

A session S_MAP1 is in Repository A. While running the session error message has displayed

1 Answers  

---