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
What is the difference between informatica 7.0 and 8.0?
What happens when a session fails and you click on recover?
What are the different transaction levels available in transaction control transformation?
What is a code page?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What are the databases that informatica can connect to windows?
Why filter transformation is an active one?
What is a joiner transformation and why it is an active one?
How to load a Dimension ? and how to load a fact table?
define galaxy repository in informatica
can u give example for factless fact table
Make a note of the quantity vaults made in informatica?
How to extract the informatica rejected data?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
Why sorter is an active transformation?