Answer / dr.jornalist

with the help of Stored procedures as well as SQL Override

Answer / bsgsr

an oracle function also can serve the purpose

Answer / abhishek

yes first answer is right but through unconnectet lookup
also we can import sequence into informatica

when will we go for unconnected lookup transformation in Informatica?

6 Answers   CTS, IBM,

---

every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.

1 Answers   IBM,

---

i have 50500 records in my source.if wf run for the first time it will load 1000 records into 1 tgt,if runs second time it will load to another tgt.targets are FF and it is need to be created dynamically.how many tgt will be created and how?

1 Answers   HCL,

---

What is persistent lookup cache?

0 Answers  

---

If u select groupby port in aggregator what is output and dont select groupby option what is output

2 Answers  

---

What are ETL Tools?

0 Answers   Informatica,

---

What is transformation?

0 Answers  

---

I Have 100 Records in a relational tble and i want to load the record in 3 targets , first records goes to target 1 and second to target 2 and third to target 3 and so on ,what are the tx used in this and what are the logics ,can any one help me ?? Thanks in Advance

6 Answers   IBM, TCS,

---

why we use datawarehouse

0 Answers   HCL,

---

How to get rid of non ascii characters in a string? Ex:- United States Microsoft Visual Studio Tools for Applications 2012 x86 主控支援 - 繁體中文語言套件 to United States Microsoft Visual Studio Tools for Applications 2012 x86.

1 Answers   CTS,

---

i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need

7 Answers   Deloitte,

---

What is CHECK-IN CHECK-OUT. Please explane me?

3 Answers   TCS,

---