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
- 14032 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / chandu
By using filter transformation we can achieve this scenario.
Filter condition :column>=4 and column name<=6
| Is This Answer Correct ? | 4 Yes | 14 No |
Post New Answer View All Answers
What does refresh system mean, and what are its distinctive choice?
What are the different types of repositories created using informatica?
CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks
Where are the source flat files kept before running the session?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What is meant by target load plan?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What is sq transformation?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
Explain in detail scd type 2 through mapping.
What is data movement mode in Informatica and difference between them?
What is the scenario which compels informatica server to reject files?
How to start a workflow using pmcmd command?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Explain the informatica workflow?
