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
- 14350 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
Reusable transformation and shortcut differences
can we override a native sql query within informatica? Where do we do it?
Explain what transformation and how many are there in informatica?
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.
Target increases every day even though no new record was inserted
What is rank transform?
Performance tuning( what you did in performance tuning)
Where can we find the throughput option in informatica?
What are the limitations of joiner transformation?
can u give example for factless fact table
How do you use reject loader.
What is workflow monitor?
What are the different versions of informatica?
What are the different types of repositories created using informatica?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
