how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
2627Post New Thomson ETL Interview Questions
What is the difference between “constant” and “readonly” variables in c#?
What is the purpose of the linux?
What do you understand by mixin or higher order components in reactjs?
What is object data type?
Is postgresql a programming language?
Explain what is an oxidizing agent?
What happens when you execute python == python?
What is the concept of view state in asp.net?
How many ways can you create rdd in spark?
What is the syntax of ui object identifier used by dom extension?
What is the difference between a mutex and a semaphore in Linux?
What is the diff. between Synthesized hopping and Baseband hopping
Some images look different when synced to the device and read programmaticaly. Do decoders change these?
How many null values we can have in a unique key field in sql server?
I have two For loop, first For loop does is creates a customer and input the customer info and then the second for loop within the first for loop does the follows which is capture the customer name and verify the with the data within the datatable. The problem I am coming across is that when it goes through the second time creating another customer and then verify the second customer then it creates the following during runtime. I want is to have the customer2 below Customer1 under the Customer_from_Apps. Any help will be greatly appreciate it. Customer Customer_from_Apps Customer_from_Apps1 Customer1 Customer 1 Customer2 Customer2 Window("Customer Desktop").Window("Customer Tracking (Privacy").WinObject("TreeView20WndClass").Click 92,244 runtimevalue = .VbTreeView("vbname:=AppServerTree").GetROProperty("Selectio n") Customer_Val= Datatable.GlobalSheet.AddParameter ("Customer_from_Apps",runtimevalue) row=datatable.getsheet("Global").GetRowCount For x=1 to row datatable.SetCurrentRow(x) Data_Val=Datatable.Value("Customer",dtGlobalSheet) If (trim(Customer_Val)=trim(Data_Val)) Then Reporter.ReportEvent micPass, "Customer validation successful", "Actual Value: " &Data_Val&vbcrlf& "Customer Value: " &Customer_Val else Reporter.ReportEvent micFail, "Cusotmer validation unsuccessful", "Actual Value: " &Data_Val&vbcrlf& "Customer Value: " &Customer_Val End If Next