i have oracle table A and target B. i don't know how many
records. i want get get last record in table A as first record
in target table B. write a sql query?
Answer Posted / upendra
In Informatica mapping we can find source A last record into Target B first record.
SRC-->Rank--> TGT
note:rank transformation edit propertities tab assign bottom=1
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are the transformations that are not supported in mapplet?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Define pmcmd command?
What is Data Caches size?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
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
How to delete duplicate row using informatica?
Difference between Data and Index Caches?
What is the use of transformation?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
How are indexes created after completing the load process?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What is olap (on-line analytical processing?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Explain about Informatica server process that how it works relates to mapping variables?