Interested to Buy Any Domain ? << Click Here >> for more details...
1
2
3
*
4
5
6
*
7
8
9
how to load records between two stars(*),
- 10 Answers
- 14033 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / lakshmi
Use Replacechr() in Expression T/r after Source Qualifier
and replace '*' with Space
Then In Filter T/r Use Filter condition as below
iif(isspaces(field,0,1))
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How to load last n records of file into target table - informatica
What is rank transform?
What is the use of an aggregator cache file?
What are the tasks that source qualifier perform?
As union transformation gives UNION ALL output, how you will get the UNION output?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Enlist some properties of sessions.
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
How to load the data from a flat file into the target where the source flat file name changes daily?
What are the issues you have faced in your project? How did you overcome those issues?
How big was your fact table
State the limitations where we cannot use joiner in the mapping pipeline?
How to update a particular record in target with out running whole workflow?
What is rank index in rank transformation?
