What are the types of metadata that stores in repository?
Answers were Sorted based on User's Feedback
Answer / mahesh
Following r the types of metadata that stores in the
repository
Database connections
Global objects
Mappings
Mapplets
Multidimensional metadata
Reusable transformations
Sessions and batches
Short cuts
Source definitions
Target definitions
Transformations
Is This Answer Correct ? | 6 Yes | 1 No |
Answer / usha
Repository which is used to store metadata...
Metadata is nothing but ..
1:-structure of the source table and target table..
2:-mapping
Is This Answer Correct ? | 1 Yes | 1 No |
How to load the data into target table, which not have Primary/Surrogate key (Duplicate records not acceptable)
write s sql query following table some duplicate present i want unique one column duplicate another column display? name id a 1 a 1 b 2 b 2 c 3 i want the required output like unique duplicate name id name id a 1 a 1 b 2 b 2 c 3
Source is a flat file and want to load unique and duplicate records separately into two separate targets; right??
Have you worked with/created Parameter file
How do you load only null records into target?
we have table like cust_id,cust_name,cust_loc like this 1.we need to get perticular location,to do this we can use filter transformatin,that logic is same for relation table and flat file tabl?
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
What is rank index in rank transformation?
What is the main data object present inbetween source and target. I answered Mapping. Transformation etc.. But it is not the answer. So please give me an apt answer. Thanks in advance
Could you explain what is enterprise data warehouse?
How to delete first 3 rows & last 3 rows in target table in informatica
How can we update a record in the target table without using update strategy?