Use Filter transformation with below condition: IIF(FIELD!='*',1

1
2
3
*
4
5
6
*
7
8
9

how to load records between two stars(*),

Question Posted / anas furquan

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

Please Help Members By Posting Answers For Below Questions

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

7071

As union transformation gives UNION ALL output, how you will get the UNION output?

1108

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2078

What is workflow? What are the components of workflow manager?

1179

wf dont have integration severances how you can run?

1941

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6190

What are the guidelines to be followed while using union transformation?

1146

How can we create index after completion of load process?

1126

Define Pmrep command?

1068

Explain why we use partitioning the session in informatica?

1096

Explain transaction control transformation in informatica

1271

Can we create multiple integration service on single repository?

1190

How can you validate all mappings in the repository simultaneously?

1372

Explain what transformation and how many are there in informatica?

960

What is a joiner transformation and why it is an active one?

1085