1
2
3
*
4
5
6
*
7
8
9
how to load records between two stars(*),
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
Explain the different dimensions.
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
How union transformation is used?
Differentiate between joiner and lookup transformation?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
Enlist the tasks for which source qualifier transformation is used.
What is the procedure for creating independent data marts from informatica 7.1?
What is meant by pre and post session shell command?
Which development components of informatica have the highest usage?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
Can informatica load heterogeneous targets from heterogeneous sources?
How to go to the older version for a mapping?
Explain the shared cache and re-cache?
What is deployment group?
What are the advantages of using informatica as an etl tool over teradata?