1
2
3
*
4
5
6
*
7
8
9
how to load records between two stars(*),
Answer Posted / anas furquan
Use Filter transformation with below condition:
IIF(FIELD!='*',1,0)
Mapping:
Source-->SQ-->Filter-->Target
This works. :)
Is This Answer Correct ? | 1 Yes | 8 No |
Post New Answer View All Answers
What do you mean by worklet?
What is mapping debugger?
I have a flat file, want to reverse the contents of the flat file
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
How an expression transformation differs from aggregator transformation?
What are the advantages of using informatica as an etl tool over teradata?
How to create the source and target database connections in server manager?
What is rank transformation?
What is persistent lookup cache?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What are the types of presistent cache in look up tr.
What happens when a session fails and you click on recover?
How can we use mapping variables in informatica? Where do we use them?
What is a router transformation?