Interested to Buy Any Domain ? << Click Here >> for more details...
supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How
4 15229suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping?how
CTS,
4 11217can v update d records in target using update stargey without generationg primary key ? explain
CTS,
4 17027hw to load this give the mapping? cty state o/p c1 s1 c1 c1 s2 s1 c1 s1 c1 c2 s3 s2 c3 s4 c1 c3 s2 s1 c2 s3 c3 s4 c3 s2 2 columns should be loaded to one column in target table?
1 7681Had any one faced informatica(ETL/Developer), Datawarehouseing interview in UK. Than plz help me (i have any exprience of 3yrs informatica,datawarehousing,oracle,teradata) 1.hw the procedure will b here 2. wht type of question's they will b asking. 3.In which area they concertate more. since this is the first time im facing interview in UK. plz help ASAP.it will b a great help for me thanks to All in Advance
2 8429In mapping f.f as one src and f.f as trg,f.f as src and oracle as trg which is fast? mean which is complete first process
2 7595hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 b 200 100 n 300 400 p 3000 100 a 100 600 x 6000 Now i want to load half of this data into one flat file and remaining in other flat file.like :- flat file 1 id name amt 100 a 100 200 b 200 100 n 300 ---------------------- ---------------------- flat file 2 id name amt 400 p 3000 100 a 100 600 x 6000 Plz reply me ASAP.
10 16872when i was running the seesion, after loading 100 records, session suddenly fails.Next time i want to load the remaing rows in target with out truncate target table.What should i use?
7 17631Hi Every One When i Start the Workflow, Table is Going to be Stored in the target database But the columns are not going to the target database table in my PC , please give me the solution and waiting for solution
2 5595What is the actual work done in Development and in the production depts in building a datawarehouse. Which dept is more interesting and career oriented .
1 4534Post New Informatica Questions
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
difference between repository database and repository service?
Tell me about MD5 functions in informatica
Repository user profiles
can u give example for factless fact table
What is informatica powercenter repository?
Please let me know how to make Data masking in informatica..
What are the features of complex mapping?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
How you know when to use a static cache and dynamic cache in lookup transformation?
What the difference is between a database, a data warehouse and a data mart?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
How to load the data from a flat file into the target where the source flat file name changes daily?
what is the size of u r source(like file or table)?
