Answer Posted / mehul thakur

Hi Rajesh
could you plz tell me the steps to join from joiner tr.

Regards
Mehul Thakur

How can we use mapping variables in informatica? Where do we use them?

1291

---

How do you take back up of repository?

1209

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

2087

---

How do you update the records with or without using update strategy?

1164

---

What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

1250

---

What is the commit type if you have a transaction control transformation in the mapping?

1100

---

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

2004

---

How many types of sessions are there in informatica.please explain them?

1211

---

what are 3 tech challenges/ common issues you face?

2397

---

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2445

---

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

2902

---

What is fact table? Explain the different kinds of facts.

1126

---

Explain the etl program with few examples.

1115

---

What do you understand by a term domain?

1173

---

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

2405

---