Why you use repository connectivity?
Answers were Sorted based on User's Feedback
Answer / swetha
When you edit, schedule the sesion each time, informatica
server directly communicates the repository to check whether
or not the session and users are valid. All the metadata of
sessions and mappings will be stored in repository.
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / satishkumar kundeti
When you edit, schedule the sesion each time, informatica
server directly communicates the repository to check whether
or not the session and users are valid. All the metadata of
sessions and mappings will be stored in repository.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / ravi
The repository is a relational database that stores
information or metadata used by the informatica server and
client tools. The metadata stores the information regarding
mappings,mapplets,sessions,batches,shortcuts,source
definitions,target definitions and many more...
| Is This Answer Correct ? | 0 Yes | 5 No |
How many input parameters can exist in an unconnected lookup?
How to delete duplicate records in a flat file source?
Tell me about Propagate functions in informatica
There are two sessions are connected to the workflow. When the first session run load the data(employees data sum_salaries <= 1000000) into the target1. When the second session run load the data(employees data sum_salaries > 1000000) into the target2. How to achieve this?
What is the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?
What are the issues that you have faced while moving your project from the Test Environment to the Production Environment?
Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio
How do you convert single row from source into three rows into target?
My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following EmpID, Salary, Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103, 3000, 6000). Please guide on how to build the mapping.
When you move from devel to prod how will you retain a variable
delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses
normalizer transformation