How to list Top 10 salary, without using Rank Transmission?
Answer Posted / cool
use sorter transformation with ascending,sequence and filter....
Is This Answer Correct ? | 18 Yes | 2 No |
Post New Answer View All Answers
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
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
Mention some types of transformation?
What does “tail –f” command do and what is its use as an Informatica admin.
How an expression transformation differs from aggregator transformation?
What does update strategy mean, and what are the different option of it?
What do you mean incremental aggregation?
what is the complex transformation you used in informatica
what is informatica metadata?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Explain pushdown optimization and types in informatica
How might you approve all mappings in the archive all the while?
Explain the use of aggregator cache file?
What are the designer tools for creating transformations?