Answer / akash

I am not aware of conformed fact but conformed dimension
tables exist.
A conformed dimension is one which is used by more than one
fact table. A classic example of conformed table is a
dimension table which has date fields.

Please let me know if conformed facts exist and their
definition.

Answer / sanjay

A fact which can be used across multiple datamart is called
as confirmed fact. Confirmed fact allows having the same
name in different table.

suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer

1 Answers   TCS,

---

What is the function of aggregator transformation?

0 Answers  

---

Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000. but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer

0 Answers  

---

What is the difference between a connected look up and unconnected lookup?

0 Answers  

---

What is a data modeling?

2 Answers  

---

Is it any possible to using more than one port in Unconnected Lookup Transformation( :LKP.LKP_Prod(Prod_GRP ,Prod_DT,Prod_TM) ) Like this? Pls explain...

3 Answers  

---

What is informatica?

0 Answers  

---

How do u identify or filter out a 0 byte file available in a folder by using UNIX command?

1 Answers   Wipro,

---

Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

0 Answers  

---

Design a mapping to load a target table with the following values from the above source?

0 Answers   Informatica,

---

Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.

0 Answers  

---

my source is junk data how will u remove that junk data by using unix please any one replay me

0 Answers   Cap Gemini,

---