Interested to Buy Any Domain ? << Click Here >> for more details...
Flat file heaving 1 lack records and I want to push 52000
records to the target?
- 7 Answers
- 14787 Views
- I also Faced
- E-Mail Answers
Answer Posted / pushpa
the answer number 5 for relational database objects only.
if the source is flat file we don't generate any SQL query in
the source qualifier.
then we are using the following way,
seqgen
|
sd-->sq-->expr-->filter--> td.
in the filter condition expression we take nextval<=52000.
| Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
What are roles and groups and benefits of using them?
Briefly define a session task?
What if the source is a flat-file?
Explain the pipeline partition with real time example?
Where are the source flat files kept before running the session?
How many ways a relational source definition can be updated and what are they?
What are the limitations of joiner transformation?
Explain sql transformation in script mode examples in informatica
Where is metadata stored?
What is difference between a gateway node and worker node?
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
How to elaborate powercenter integration service?
What are connected or unconnected transformations?
Explain in detail scd type 2 through mapping.
lookup transformation with screenshots
