Interested to Buy Any Domain ? << Click Here >> for more details...
source which format u will get either fixed or delimiter length format? what is the symbol of delimiter?
2 6256how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
23291)i put Pharma Project in my Resume..whar are the sources used in my project Generally? 2)how many fact and dimensional tables used? 3)Have u used any Datamarts and measues in fact table? ....plz give the answers...
2 77072.how u run your rotines in unix? what is job sequencer? if i have 4 jobs i would like to run 2 jobs in server(using job jobsequencer)and remaining 2 in parallel?how can i run?
1 5631i have a some records eno ename acono amount 1001 suresh sbi101 12000 1001 suresh sbi101 14000 1001 is dublicata how can i remove duplicate?
4 8593eno ename esal acct1 acct2 amount1 amount2 100 suresh 10000 sbi1 sbi2 1000 2000 this is our sourse data i would loke to disply like this eno ename esal acct amount 100 suresh 10000 sbi1 1000 100 suresh 10000 sbi2 2000
HCL,
2 83811.what is stagearea?what is stage variable? 2.this is my source source:id, name target:id, name 100, murty 100,madan we have three duplicate records for the id column,how can we getthe source record? 100,madan 100,saran
HCL,
1 72421.which index is follows the dimensions tables?why? 2.what is the use of trigger in job sequence? 3.what is the mean of optimization? 4.what is the job control?when we use it? what is difference bet batch and sequencer? 6.seq--->seq,seq--->copy--->seq which one is best and efficient?
1 55401.i have 5 jobs(1-5),i connect with each other,i want run from 3-5 only how? 2.how to schedual the job in datastage7.5 2? what is the deff bet grip and fgrep command? how do you cleanse the data in your project
1 4484i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
2681if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables?chandu how can i implement scd typ1 and type2 in both server and in parallel?chandu field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the ,inthe fields?
2 6828In my project source data comes from MAINFRAME in files.so,This time data is coming as a binary file...I know for binary data we use Complex flat file stage..I have used it also..but on 'view data' data is not coming correctly..as it in MAINFRAME.give me some ideas..
2 11481i have a small question for datastage, After the desinging (i.e., transformations and loading)part, what we can do?
TCS,
1 3793
What are the different options associated with dsjob command?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
What is the difference between validated and compiled in the datastage?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
Can you explain engine tier in information server?
Explain usage analysis in datastage?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
sed,awk,head
What is "fatal error/rdbms code 3996" error?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What is the difference between Datastage 7.5 and 7.0?
What is the difference between in process and inter process?
What are stage variables?
