Interested to Buy Any Domain ? << Click Here >> for more details...
if we hav 10 records in a file, can we get first record from
it by using Aggregator with out using Groupby Port in it?If
Yes..let me know the answer plz!!!
- 8 Answers
- 29466 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / bala
@abhinav...
How can you sort records by using rownum...its not possible
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What are the mapping parameters and mapping variables?
What is the need of an ETL tool?
While migrating the data from one environment to another environment how would you manage the connections?
Design time, run time. If you don't create parameter what will happen
What is a difference between complete, stop and abort?
What do you mean incremental aggregation?
What is the difference between stop and abort in informatica
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What is meant by LDAP users?
what is the hint? how to use it to reduce the query processing in program?
What is meant by query override?
How to start a workflow using pmcmd command?
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 do you take back up of repository?
How can we remove the duplicates from flat file source?
