Answer Posted / venkat

Hi Mukesh,

This is venkat can you please send informatica
certification to my mail id is prasad.reddy3449@gmail.com

Thanks in Advance
venkat

What is the different lookup cache(s)?

1086

---

What is the use of transformation?

998

---

Write the prerequisite tasks to achieve the session partition?

1158

---

What are roles and groups and benefits of using them?

1057

---

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

2182

---

hi real timers . iam waiting for ur reply regarding ETL TESTING

2271

---

What are the main issues while working with flat files as source and as targets ?

1159

---

What are Dimensional table?

1055

---

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1248

---

CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks

9134

---

Write the unconnected lookup syntax?

1084

---

How to generate sequence numbers?

1088

---

What is the sql query overwrite in source qualifier in informatica

1090

---

What is depict expression change?

1120

---

How to load a Dimension ? and how to load a fact table?

1418

---