1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

from Source 100 rows are coming, on target there are 5 m
rows which options is better to match data

1. Joiner
2 No cache
3. Static
4. Dynamic

Question Posted / sudhakatr.lake

Answer Posted / sudhakatr.lake

Static

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is informatica metadata and where is it stored?

587

what is the size ur source like(file system or database)? how many record daily come u r banking project?

1744

What is a router transformation?

628

what is $$$$?

1737

Name at least 5 different types of transformations used in mapping design and state the use of each.?

670




How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

695

What does command task mean?

610

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

7797

which one is better performance wise joiner or look up

626

How can we use batches?

604

Different sorts of metadata that stores in the storage facility?

559

How can we delete duplicate rows from flat files?

740

What is an active transformation?

648

Enlist some properties of sessions.

626

How to do unit testing in informatica? How to load data in informatica ?

648