Answer / vikram

Workflow variable is similar to Mapping variable where as
in workflow variable we will pass the workflow statistics
and suppose you want to configure the multiple run of
workflows by using varable that you can do with this.

What is informatica? Why do we need it?

0 Answers  

---

HOW DO YOU PARFORM INCREMENTAL LAOD ?

7 Answers   SAIC,

---

What are parallel querys and query hints?

1 Answers  

---

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

2 Answers   TCS,

---

In which transformation you cannot drag ports into it?

0 Answers   Informatica,

---

---

How you count the number of records available at your source?

3 Answers   Zensar,

---

What is best approach to load 100 different source files (Different structure) to differet target tables ?

2 Answers   IBM, TCS,

---

get me output as if input is like 1 x o/p-->1 x,y,z 1 y 2 a,b 1 z 3 c 2 a 2 b 3 c

0 Answers   Infosys,

---

hi,there is a scenario like. there are three columns empid,salmonth, sal contains the values 101,jan,1000 101 feb 1000 like twelve rows are there then my required out put is like contains 13 columns empid jan feb marc.......dec and the velues are 101 1000 1000 1000 like this . thank you

5 Answers   Patni,

---

what is rank and dense rank in informatica with any examples and give sql query for this both ranks

4 Answers  

---

Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio

4 Answers   IBM,

---

what is a time dimension? give an example?

2 Answers   IBM,

---