i have one source 52 million records i want target only 7
records ?how wil you do what logic to implement?
- 7 Answers
- 11738 Views
- L&T, I also Faced
- E-Mail Answers
Answer Posted / jacob
take one sequence generator and poppulate the sequence nos
to all rows then give condition as sequence no<=7.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is an aggregator transformation?
What is expression transformation?
Which transformation is needed while using the Cobol sources as source definitions?
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
Explain lookup transformation source types in informatica
What is a repository? And how to add it in an informatica client?
What is an Integration service in Informatica?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What are the advantages of using informatica as an etl tool over teradata?
What is the meaning of up gradation of repository?
State the differences between sql override and lookup override?
What is a shortcut and copy in Informatica and how two are different with each other?
How does a sorter cache works?
What is informatica? Why do we need it?
Explain the informatica workflow?
