how many session run unix environment what command using ?
Answer / shruthi
If you are asking about the command to run a seesion in
unix environment then it is PMCMD
correct me if i was wrong
Is This Answer Correct ? | 7 Yes | 2 No |
why do we go for update strategy tr in SCD rather using the session properties?
Dovelopment work (mapings,workflows)and unit testing also done in informatica ,then wt we do ? pls give me detail?
Source-1 No name 1 satish 2 karthik 3 swathi 4 keerthi Source-2 No name 1 satish 2 karthik 5 santhose 6 vasu Target 3 swathi 4 keerthi 5 santhose 6 vasu here i want non matching Records i want how to achieve that
Can we use parameters of parameter file in presession command
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is main use of mapplet?
which one is better performance wise joiner or look up
Different types of Power center errors?
what is datamart
Suppose we have a (assume relational) source table Product_Id Month Sales 1 Jan x 1 Feb x . . . . . . 1 Dec x 2 Jan x 2 Feb x . . . . . . 2 Dec x 3 Jan x 3 Feb x . . . . . . 3 Dec x . . . . . . and so on. Assume that there could be any number of product keys and for each product key the sales figures (denoted by 'x' are stored for each of the 12 months from Jan to Dec). So we want the result in the target table in the following form. Product_id Jan Feb March.. Dec 1 x x x x 2 x x x x 3 x x x x . . So how will you design the ETL mapping for this case , explain in temrs of transformations.
in mapping i have one source and five targets in that data will be loaded into four targets properily in one target the data is not loaded how will u rectify
How to call shell scripts from informatica?