Answer / Nishant Mehta

To generate sequence numbers using Expression Transformation in Informatica, you can use the following expression: "SeqNum = Row_number() over (order by column1)". Replace 'column1' with the column on which you want to generate the sequence number.

How do schedule a workflow in Informatica thrice in a day? Like run the workflow at 3am, 5am and 4pm?

3 Answers   Logica CMG,

---

what is the -ve test case in your project.

1 Answers   CTS, TCS,

---

What is lookup transformation?

1 Answers  

---

select count(1) from emp? what is the o/p?

5 Answers   TCS,

---

Could anyone please mail me a copy of Informatica Certification Exam dumps to sandeep.nakka@gmail.com it would be appreciated if any one could help me out.

0 Answers  

---

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

2 Answers   TCS,

---

How to view and Generate Metadata Reports?

1 Answers  

---

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

1 Answers  

---

Explain the etl program with few examples.

1 Answers  

---

how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy

2 Answers   TCS,

---

Explain reference cursor?

1 Answers  

---

what is tha tracesing level? and difference betweentrace in normal and verbose and nonverbose?

2 Answers  

---