in informatica,if i have some no.of records,if i want 1st
and 10th records..what will be the method to use?
Answer Posted / sathish
source may be flat file or database just you use sequence ganarater then filter copy the nextval port to filter write condition nextval=1 or nextval=10 you get only 1 and 10 th records
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
As union transformation gives UNION ALL output, how you will get the UNION output?
Explain the scenario which compels informatica server to reject files?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What are the different options available for update strategy?
How to extract sap data using informatica? What is abap? What are idocs?
Which files are created during the session rums by informatics server?
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
What does role playing dimension mean?
What if the source is a flat-file?
Do you find any difficulty while working with flat files as source and target?
What are the settings that you use to configure the joiner transformation?
How can we create index after completion of load process?
Describe the impact of several join conditions and join order in a joiner transformation?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Performance tuning( what you did in performance tuning)