1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

There are 100 lines in a file. How to print line number 31-50 and 81-90 in unix with a single command.

Question Posted / vc

Answer Posted / vc

sed -n -e '31,50p' -e '81,90p' filename.txt

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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.

777

What is a passive transformation?

646

What are the mapping parameters and mapping variables?

624

What are the types of presistent cache in look up tr.

1551

have u done any performance tuning? how u ll do?

1861




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

7821

What are the types of data warehouses?

948

How many ways are there to create ports?

731

Which transformation should we use to normalise the COBOL and relational sources?

748

How to load the name of the current processing flat file along with the data into the target using informatica mapping?

702

how to create user defined function (udf) in informatica

787

What is the Rank index port in Rank transformation?

672

How to do unit testing in informatica? How to load data in informatica ?

655

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

609

Explian the Process of deployment groups in informatica

659