Interested to Buy Any Domain ? << Click Here >> for more details...
How to load only the first and last record of a flat file into
the target?
- 3 Answers
- 9787 Views
- Mind Tree, I also Faced
- E-Mail Answers
Answer Posted / yaseen
After SQ place 2 Rank T/R and a reusable sequence generator T/R having start value 1. In 1st Rank give the top 1 and in 2nd Rank set bottom 1
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
Different qualification between a related rotate toward the sky and isolates look upward?
What are the different transaction levels available in transaction control transformation?
whats the logic to load the lower level of granularity of data to fact table.
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Explain the mapping variable usage example in informatica
How might one distinguish in the case of mapping is right or not without associating session?
list out all the transformations which use cache?
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
Explian the Process of deployment groups in informatica
What is the use of target designer?
What are the advantages of informatica?
Explain in detail about scd type 1 through mapping.
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What are the designer tools for creating transformations?
Do you find any difficulty while working with flat files as source and target?
