Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sarath
1)We can use flat file as a target
2)we can use flat file as a lookup
3)Mainly union t/r is introuduced in 7.1
4)Data profiling and versioning
5)Propagate attributes
6)we can do partiotions upto 64
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is exclusive and normal mode for repository services?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is source qualifier transformation in informatica?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
lookup transformation with screenshots
Please let me know how to make encryption and decryption with example?
Which means the first record should come as last record and last record should come as first record and load into the target file?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What does command task mean?
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
What is the benefit of partitioning a session?
Explain sessions?
What is sorter transformation?
How many numbers of sessions can one group in batches?
Explain the etl program with few examples.
