Latest Answer : Madhu, Here is the statement to start/stop a session....$PM_HOME/pmcmd starttask -s $PM_PMSERVER_PORT -uv USERNAME -pv PASSWORD -wait -f $Folder -w $Workflow $Task# ...
Latest Answer : No GUI mode for informatica in unix. In Unix you cannot design the mappings and workflow as you do in windows. Unix operating sys can only be used to run the jobs, schudule it...
Sidhu ...
Write Sample Script to schedule sessions and workflows. one in GUI mode and the other in batch mode.
I am asked to create a detailed metadata about ,transformations used in perticular fact table mapping.How do i understand and create write up on what has happened to each port during each tranformations?By right click on port in target definition and choosing backward path , I could get complete path fot that port.Pls. adviseThanks,
Can anyone please explain how i can write a subquery in the expression editor of a filter transformation (i need the syntax to write in the expression editor)thanksnayana
Hi, I have a COBOL file and contains 500 records of sample data.It contains 200 columns.How can I split that file in Informatica?Like 1st file 1-80 columns and 2nd file 81-200 columns.Then I want load that data using Informatica.The Target are Oracle tables.1-80 columns: 1st target81-200 columns:2nd targetHow can I split that single COBOL file data into two data files and How can I load that data using Informatica.Thanks in Advance
Hi,
I have a COBOL file and contains 500 records of sample data.It contains 200 columns.How can I split that file in Informatica?Like 1st file 1-80 columns and 2nd file 81-200 columns.Then I want load that data using Informatica.
The Target are Oracle tables.
1-80 columns: 1st target
81-200 columns:2nd target
How can I split that single COBOL file data into two data files and How can I load that data using Informatica.
Thanks in Advance
I need to know what to fill in Specialization Field of DRDO biodata Form. It require all details . I had just Completed B.tech(CSE).What I should write in this Field.
The reason behind the failure of session is PMF_15001 Failed to write to file there may not be enough space left on the device.Means there is some problem in cache directory space.Please suggest me how I can handle this situation without increasing the disk space.
Write a query to retrieve latest records from the target table means if we have used scd2 version type of dimension, than retrieve the record with highest version no.for eg verno id loc 1 100 bang 2 100 kol 1 101 bang 2 101 chenwe have to retrieve 100/kol and 101/chen. how it is possible through query.
